﻿<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="ViewRosters.aspx.vb" Inherits="TWIN_test.ViewRoster" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Workshop Roster</title>
</head>
<body background="/Images/Training-Instructor-Background.gif"> 
    <form id="form1" runat="server">
   <center><div>
        Workshop Members<br />
        <asp:DataList ID="DataList1" runat="server" DataSourceID="SqlDataSource1">
            <ItemTemplate>
                USERNAME:
                <asp:Label ID="USERNAMELabel" runat="server" Text='<%# Eval("USERNAME") %>' />
                <br />
<br />
            </ItemTemplate>
        </asp:DataList>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString2 %>" 
            ProviderName="<%$ ConnectionStrings:ConnectionString2.ProviderName %>" 
            SelectCommand="SELECT DISTINCT &quot;USERNAME&quot; FROM &quot;WORKSHOPS_TAKEN&quot; WHERE (&quot;WORKSHOP_ID&quot; = :WORKSHOP_ID)">
            <SelectParameters>
                <asp:QueryStringParameter DefaultValue="" Name="WORKSHOP_ID" 
                    QueryStringField="id" Type="Decimal" />
            </SelectParameters>
        </asp:SqlDataSource>
        <br />
        <asp:Button ID="viewDetailsButton" runat="server" Text="View Details" />

        <asp:Button ID="backButton" runat="server" Text="Back" />

    </center></div>
    </form>
</body>
</html>
